<cfset thisdate = now()>
<cfset thisdate = dateadd("d", -2, thisdate)>
<cfquery name="qstats" datasource="#request.dsn#">
UPDATE afl_tracking
SET dt = #createodbcdatetime(thisdate)#,
clickid = 0,
viewid = 0
</cfquery>
Done